/*
 * Copyright (c) 2008, Spagettikod | Stockholm
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   * Redistributions of source code must retain the above copyright notice,
 *     this list of conditions and the following disclaimer.
 *   * Redistributions in binary form must reproduce the above copyright
 *     notice, this list of conditions and the following disclaimer in the
 *     documentation and/or other materials provided with the distribution.
 *   * Neither the name of the Spagettikod | Stockholm nor the names of its
 *     contributors may be used to endorse or promote products derived from
 *     this software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package com.spagettikod.t437;

import java.util.Hashtable;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import javax.swing.table.AbstractTableModel;

import com.xerox.amazonws.sdb.Domain;
import com.xerox.amazonws.sdb.Item;
import com.xerox.amazonws.sdb.ItemAttribute;
import com.xerox.amazonws.sdb.SDBException;
import com.xerox.amazonws.sdb.SimpleDB;

public class SimpleDBTableModel extends AbstractTableModel
{

	private static final long serialVersionUID = -5552521277819622631L;

	private List<String> itemKeys = new LinkedList<String>();

	private SimpleDB connection;

	private LinkedList<String> columnNames = new LinkedList<String>();

	private LinkedList<Hashtable<String, String>> columnValues = new LinkedList<Hashtable<String, String>>();

	public SimpleDBTableModel(SimpleDB connection)
	{
		this.connection = connection;
	}

	public void loadDomain(Domain domain)
	{
		try
		{
			List<Item> itemList = domain.listItems().getItemList();

			columnNames.clear();
			columnValues.clear();
			itemKeys.clear();

			for (Item item : itemList)
			{
				itemKeys.add(item.getIdentifier());
			}

			Map<String, List<ItemAttribute>> items = domain.getItemsAttributes(itemKeys);

			columnNames.add("Identifier");
			itemKeys.clear();
			for (String key : items.keySet())
			{
				List<ItemAttribute> attributes = items.get(key);
				itemKeys.add(key);
				Hashtable<String, String> cols = new Hashtable<String, String>();
				for (ItemAttribute attr : attributes)
				{
					String name = attr.getName();
					if (!columnNames.contains(name))
					{
						columnNames.add(name);
					}
					String currValue = cols.get(name);
					if (currValue == null)
					{
						cols.put(name, attr.getValue());
					}
					else
					{
						cols.put(name, currValue + ", " + attr.getValue());
					}
				}
				columnValues.add(cols);
			}

			super.fireTableStructureChanged();
		}
		catch (SDBException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void loadDomain(String domainName)
	{
		try
		{
			Domain domain = connection.getDomain(domainName);
			loadDomain(domain);
		}
		catch (SDBException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	@Override
	public String getColumnName(int column)
	{
		return columnNames.get(column);
	}

	public int getColumnCount()
	{
		return columnNames.size();
	}

	public int getRowCount()
	{
		if (columnValues == null)
			return 0;
		else
			return columnValues.size();
	}

	public Object getValueAt(int rowIndex, int columnIndex)
	{
		if (columnValues == null)
		{
			return "";
		}
		else if (columnIndex == 0)
		{
			return itemKeys.get(rowIndex);
		}
		else
		{
			Hashtable<String, String> row = columnValues.get(rowIndex);
			return row.get(getColumnName(columnIndex));
		}
	}
}
